Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Case-insensitive index components

OpenEdge allows you to set the attributes of a field so that it is either case sensitive or case insensitive (case insensitive being the default). The DataServer makes this feature compatible across OpenEdge and ORACLE databases. When a field is not case sensitive, OpenEdge does not distinguish between uppercase and lowercase letters for that index when sorting or matching data. In general, this flexibility in an application makes data entry easier for end users since they can enter lowercase or uppercase versions of an index. However, when you want to enforce an uppercase/lowercase distinction in your applications, set the attribute to case sensitive. ORACLE supports case-insensitive indexes by using the UPPER(column name) function as an index component.